convert excel workbook to dataframe

35
workbook = pd.ExcelFile('***.xls')
sheets = workbook.sheet_names

df = pd.concat([pd.read_excel(workbook, sheet_name=s)
                .assign(sheet_name=s) for s in sheets])

Comments

Submit
0 Comments

More Questions

how to make a class in pythonModuleNotFoundError: No module named pip._internal httpie on windows
python read json filepandas create new column python write to file
what is the use of class in pythoninstall opencv python rename columns pandas
rename columns in pythonpip upgrade command how to upgrade pip
command to upgrade the PIPdownload pip install command to update pip
how to upgrade pip in cmdhow to check python version python iterate dictionary key value
python install pipwindows python pip upgrade python virtual environment
how to update pip in pythonhow to read a file in python how to update pip python
how to replace nan with 0 in pandascheck package version python streamlit ssl error
networkx remove nodes with degreeget wd in python find text between two strings regex python
create zero array in pythonupgrade python version mc python get image dimensions
pandas drop empty columnssummation django queryset oddlyspecific09123890183019283
convert a dictionary into dataframe pythonwrite dataframe to csv python pygame draw circle
check value vowel user input pythonremove commas from string python No module named sklearn.cross_validation
pandas version check in pythonconvert column string to int pandas python italic
python - prime number generator.annotate unique distinct current datetime pandas
C
CSS
Objective-C
PHP
Java
C++
Javascript
Html
Python
SQL
Swift
Ruby
Go
R
TypeScript
Kotlin
Assembly
VBA
Scala
Rust
Elixir
Dart
Haskell
Perl
Fortran
Matlab
Scheme
Julia
Lua
Delphi
Pascal
Solidity
BASIC
ActionScript
Csharp